Hệ thống quản lý bệnh viện bằng C# với mã nguồn

1 <?xml version="1.0" encoding="utf-8"?>
2 <xs:schema id=
"hospitalDataSet2" targetNamespace="http://tempuri.org/hospitalDataSet2.xsd" xmlns:mstns="http://tempuri.org/hospitalDataSet2.xsd" xmlns="http://tempuri.org/hospitalDataSet2.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
3   <xs:annotation>
4     <xs:appinfo source=
"urn:schemas-microsoft-com:xml-msdatasource">
5       <DataSource DefaultConnectionIndex=
"0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
6         <Connections>
7           <Connection AppSettingsObjectName=
"Settings" AppSettingsPropertyName="hospitalConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="hospitalConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.HospitalManagementSystemCSharp.Properties.Settings.GlobalReference.Default.hospitalConnectionString" Provider="System.Data.SqlClient" />
8         </Connections>
9         <Tables>
10           <TableAdapter BaseClass=
"System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="roomTableAdapter" GeneratorDataComponentClassName="roomTableAdapter" Name="room" UserDataComponentName="roomTableAdapter">
11             <MainSource>
12               <DbSource ConnectionRef=
"hospitalConnectionString (Settings)" DbObjectName="dbo.room" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
13                 <DeleteCommand>
14                   <DbCommand CommandType=
"Text" ModifiedByUser="false">
15                     <CommandText>DELETE FROM [dbo].[room] WHERE (([Id] = @Original_Id) AND ((@IsNull_building =
1 AND [building] IS NULL) OR ([building] = @Original_building)) AND ((@IsNull_r_type = 1 AND [r_type] IS NULL) OR ([r_type] = @Original_r_type)) AND ((@IsNull_r_no = 1 AND [r_no] IS NULL) OR ([r_no] = @Original_r_no)) AND ((@IsNull_no_bed = 1 AND [no_bed] IS NULL) OR ([no_bed] = @Original_no_bed)) AND ((@IsNull_price = 1 AND [price] IS NULL) OR ([price] = @Original_price)) AND ((@IsNull_r_status = 1 AND [r_status] IS NULL) OR ([r_status] = @Original_r_status)))</CommandText>
16                     <Parameters>
17                       <Parameter AllowDbNull=
"false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
18                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_building" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="building" SourceColumnNullMapping="true" SourceVersion="Original" />
19                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_building" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="building" SourceColumnNullMapping="false" SourceVersion="Original" />
20                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_r_type" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="r_type" SourceColumnNullMapping="true" SourceVersion="Original" />
21                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_r_type" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="r_type" SourceColumnNullMapping="false" SourceVersion="Original" />
22                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_r_no" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="r_no" SourceColumnNullMapping="true" SourceVersion="Original" />
23                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_r_no" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="r_no" SourceColumnNullMapping="false" SourceVersion="Original" />
24                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_no_bed" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="no_bed" SourceColumnNullMapping="true" SourceVersion="Original" />
25                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_no_bed" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="no_bed" SourceColumnNullMapping="false" SourceVersion="Original" />
26                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_price" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="price" SourceColumnNullMapping="true" SourceVersion="Original" />
27                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_price" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="price" SourceColumnNullMapping="false" SourceVersion="Original" />
28                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_r_status" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="r_status" SourceColumnNullMapping="true" SourceVersion="Original" />
29                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_r_status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="r_status" SourceColumnNullMapping="false" SourceVersion="Original" />
30                     </Parameters>
31                   </DbCommand>
32                 </DeleteCommand>
33                 <InsertCommand>
34                   <DbCommand CommandType=
"Text" ModifiedByUser="false">
35                     <CommandText>INSERT INTO [dbo].[room] ([building], [r_type], [r_no], [no_bed], [price], [r_status]) VALUES (@building, @r_type, @r_no, @no_bed, @price, @r_status);
36 SELECT Id, building, r_type, r_no, no_bed, price, r_status FROM room WHERE (Id = SCOPE_IDENTITY())</CommandText>
37                     <Parameters>
38                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@building" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="building" SourceColumnNullMapping="false" SourceVersion="Current" />
39                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@r_type" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="r_type" SourceColumnNullMapping="false" SourceVersion="Current" />
40                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@r_no" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="r_no" SourceColumnNullMapping="false" SourceVersion="Current" />
41                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@no_bed" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="no_bed" SourceColumnNullMapping="false" SourceVersion="Current" />
42                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@price" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="price" SourceColumnNullMapping="false" SourceVersion="Current" />
43                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@r_status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="r_status" SourceColumnNullMapping="false" SourceVersion="Current" />
44                     </Parameters>
45                   </DbCommand>
46                 </InsertCommand>
47                 <SelectCommand>
48                   <DbCommand CommandType=
"Text" ModifiedByUser="false">
49                     <CommandText>SELECT Id, building, r_type, r_no, no_bed, price, r_status FROM dbo.room</CommandText>
50                     <Parameters />
51                   </DbCommand>
52                 </SelectCommand>
53                 <UpdateCommand>
54                   <DbCommand CommandType=
"Text" ModifiedByUser="false">
55                     <CommandText>UPDATE [dbo].[room] SET [building] = @building, [r_type] = @r_type, [r_no] = @r_no, [no_bed] = @no_bed, [price] = @price, [r_status] = @r_status WHERE (([Id] = @Original_Id) AND ((@IsNull_building =
1 AND [building] IS NULL) OR ([building] = @Original_building)) AND ((@IsNull_r_type = 1 AND [r_type] IS NULL) OR ([r_type] = @Original_r_type)) AND ((@IsNull_r_no = 1 AND [r_no] IS NULL) OR ([r_no] = @Original_r_no)) AND ((@IsNull_no_bed = 1 AND [no_bed] IS NULL) OR ([no_bed] = @Original_no_bed)) AND ((@IsNull_price = 1 AND [price] IS NULL) OR ([price] = @Original_price)) AND ((@IsNull_r_status = 1 AND [r_status] IS NULL) OR ([r_status] = @Original_r_status)));
56 SELECT Id, building, r_type, r_no, no_bed, price, r_status FROM room WHERE (Id = @Id)</CommandText>
57                     <Parameters>
58                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@building" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="building" SourceColumnNullMapping="false" SourceVersion="Current" />
59                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@r_type" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="r_type" SourceColumnNullMapping="false" SourceVersion="Current" />
60                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@r_no" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="r_no" SourceColumnNullMapping="false" SourceVersion="Current" />
61                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@no_bed" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="no_bed" SourceColumnNullMapping="false" SourceVersion="Current" />
62                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@price" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="price" SourceColumnNullMapping="false" SourceVersion="Current" />
63                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@r_status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="r_status" SourceColumnNullMapping="false" SourceVersion="Current" />
64                       <Parameter AllowDbNull=
"false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
65                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_building" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="building" SourceColumnNullMapping="true" SourceVersion="Original" />
66                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_building" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="building" SourceColumnNullMapping="false" SourceVersion="Original" />
67                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_r_type" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="r_type" SourceColumnNullMapping="true" SourceVersion="Original" />
68                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_r_type" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="r_type" SourceColumnNullMapping="false" SourceVersion="Original" />
69                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_r_no" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="r_no" SourceColumnNullMapping="true" SourceVersion="Original" />
70                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_r_no" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="r_no" SourceColumnNullMapping="false" SourceVersion="Original" />
71                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_no_bed" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="no_bed" SourceColumnNullMapping="true" SourceVersion="Original" />
72                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_no_bed" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="no_bed" SourceColumnNullMapping="false" SourceVersion="Original" />
73                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_price" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="price" SourceColumnNullMapping="true" SourceVersion="Original" />
74                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_price" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="price" SourceColumnNullMapping="false" SourceVersion="Original" />
75                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_r_status" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="r_status" SourceColumnNullMapping="true" SourceVersion="Original" />
76                       <Parameter AllowDbNull=
"true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_r_status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="r_status" SourceColumnNullMapping="false" SourceVersion="Original" />
77                       <Parameter AllowDbNull=
"false" AutogeneratedName="Id" ColumnName="Id" DataSourceName="[F:\Sem.4\C# Projects\Trials\HospitalManagementSystemCSharp\HospitalManagementSystemCSharp\HOSPITAL.MDF].dbo.room" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
78                     </Parameters>
79                   </DbCommand>
80                 </UpdateCommand>
81               </DbSource>
82             </MainSource>
83             <Mappings>
84               <Mapping SourceColumn=
"Id" DataSetColumn="Id" />
85               <Mapping SourceColumn=
"building" DataSetColumn="building" />
86               <Mapping SourceColumn=
"r_type" DataSetColumn="r_type" />
87               <Mapping SourceColumn=
"r_no" DataSetColumn="r_no" />
88               <Mapping SourceColumn=
"no_bed" DataSetColumn="no_bed" />
89               <Mapping SourceColumn=
"price" DataSetColumn="price" />
90               <Mapping SourceColumn=
"r_status" DataSetColumn="r_status" />
91             </Mappings>
92             <Sources />
93           </TableAdapter>
94         </Tables>
95         <Sources />
96       </DataSource>
97     </xs:appinfo>
98   </xs:annotation>
99   <xs:element name=
"hospitalDataSet2" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="hospitalDataSet2" msprop:Generator_UserDSName="hospitalDataSet2">
100     <xs:complexType>
101       <xs:choice minOccurs=
"0" maxOccurs="unbounded">
102         <xs:element name=
"room" msprop:Generator_TableClassName="roomDataTable" msprop:Generator_TableVarName="tableroom" msprop:Generator_TablePropName="room" msprop:Generator_RowDeletingName="roomRowDeleting" msprop:Generator_RowChangingName="roomRowChanging" msprop:Generator_RowEvHandlerName="roomRowChangeEventHandler" msprop:Generator_RowDeletedName="roomRowDeleted" msprop:Generator_UserTableName="room" msprop:Generator_RowChangedName="roomRowChanged" msprop:Generator_RowEvArgName="roomRowChangeEvent" msprop:Generator_RowClassName="roomRow">
103           <xs:complexType>
104             <xs:sequence>
105               <xs:element name=
"Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
106               <xs:element name=
"building" msprop:Generator_ColumnVarNameInTable="columnbuilding" msprop:Generator_ColumnPropNameInRow="building" msprop:Generator_ColumnPropNameInTable="buildingColumn" msprop:Generator_UserColumnName="building" minOccurs="0">
107                 <xs:simpleType>
108                   <xs:restriction
base="xs:string">
109                     <xs:maxLength
value="50" />
110                   </xs:restriction>
111                 </xs:simpleType>
112               </xs:element>
113               <xs:element name=
"r_type" msprop:Generator_ColumnVarNameInTable="columnr_type" msprop:Generator_ColumnPropNameInRow="r_type" msprop:Generator_ColumnPropNameInTable="r_typeColumn" msprop:Generator_UserColumnName="r_type" minOccurs="0">
114                 <xs:simpleType>
115                   <xs:restriction
base="xs:string">
116                     <xs:maxLength
value="50" />
117                   </xs:restriction>
118                 </xs:simpleType>
119               </xs:element>
120               <xs:element name=
"r_no" msprop:Generator_ColumnVarNameInTable="columnr_no" msprop:Generator_ColumnPropNameInRow="r_no" msprop:Generator_ColumnPropNameInTable="r_noColumn" msprop:Generator_UserColumnName="r_no" minOccurs="0">
121                 <xs:simpleType>
122                   <xs:restriction
base="xs:string">
123                     <xs:maxLength
value="50" />
124                   </xs:restriction>
125                 </xs:simpleType>
126               </xs:element>
127               <xs:element name=
"no_bed" msprop:Generator_ColumnVarNameInTable="columnno_bed" msprop:Generator_ColumnPropNameInRow="no_bed" msprop:Generator_ColumnPropNameInTable="no_bedColumn" msprop:Generator_UserColumnName="no_bed" minOccurs="0">
128                 <xs:simpleType>
129                   <xs:restriction
base="xs:string">
130                     <xs:maxLength
value="50" />
131                   </xs:restriction>
132                 </xs:simpleType>
133               </xs:element>
134               <xs:element name=
"price" msprop:Generator_ColumnVarNameInTable="columnprice" msprop:Generator_ColumnPropNameInRow="price" msprop:Generator_ColumnPropNameInTable="priceColumn" msprop:Generator_UserColumnName="price" minOccurs="0">
135                 <xs:simpleType>
136                   <xs:restriction
base="xs:string">
137                     <xs:maxLength
value="50" />
138                   </xs:restriction>
139                 </xs:simpleType>
140               </xs:element>
141               <xs:element name=
"r_status" msprop:Generator_ColumnVarNameInTable="columnr_status" msprop:Generator_ColumnPropNameInRow="r_status" msprop:Generator_ColumnPropNameInTable="r_statusColumn" msprop:Generator_UserColumnName="r_status" minOccurs="0">
142                 <xs:simpleType>
143                   <xs:restriction
base="xs:string">
144                     <xs:maxLength
value="50" />
145                   </xs:restriction>
146                 </xs:simpleType>
147               </xs:element>
148             </xs:sequence>
149           </xs:complexType>
150         </xs:element>
151       </xs:choice>
152     </xs:complexType>
153     <xs:unique name=
"Constraint1" msdata:PrimaryKey="true">
154       <xs:selector xpath=
".//mstns:room" />
155       <xs:field xpath=
"mstns:Id" />
156     </xs:unique>
157   </xs:element>
158 </xs:schema>


Gõ tìm kiếm nhanh...